<?php

include __DIR__ ."../../PHP/db.php";


$job_order_id = $_POST['job_order_id'];

$phql = "SELECT 
		 jo.*,e.*
		 FROM job_order jo
		 LEFT JOIN employer e ON e.employer_id = jo.employer_id
		 WHERE job_id = {$job_order_id}";

$list = mysql_query($phql);

$result2 = array();

while($row = mysql_fetch_array($list))
{
	$result[] = $row;
	
}

$result2['data'] = $result;

echo json_encode($result2);
die;

?>